-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: mysql5.cws.oregonstate.edu
-- Generation Time: May 22, 2019 at 12:40 PM
-- Server version: 5.1.63
-- PHP Version: 5.3.3-7+squeeze9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `cw_61046`
--

-- --------------------------------------------------------

--
-- Table structure for table `CodesManagArchive`
--

CREATE TABLE IF NOT EXISTS `CodesManagArchive` (
  `ManagCode` text NOT NULL,
  `ManagDescrip` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CodesManagArchive`
--

INSERT INTO `CodesManagArchive` (`ManagCode`, `ManagDescrip`) VALUES
('AER_AIRLFT', 'Aeration unit, airlift'),
('AER_CIRC', 'Aeration management, datytime, circulation'),
('AER_CONT', 'Aeration management, continuous'),
('AER_EMERG', 'Aeration management, emergency'),
('AER_FAN', 'Aeration unit, fan, circulator'),
('AER_MINDO', 'Aeration management, responsive to minimum DO'),
('AER_NIGHT', 'Aeration management, nightime'),
('AER_NONE', 'Aeration, no unit or management'),
('AER_PUMP', 'Aeration unit, pump ???'),
('APP_PER', 'Fish rearing-unit culture-period application (after fish stocking)'),
('APP_PRE', 'Fish rearing-unit pre-treatment application (prior to fish stocking)'),
('ARM_CIRC', 'Aeration management: daytime circulation'),
('ARM_CONT', 'Aeration management: continuous'),
('ARM_EMERG', 'Aeration management: emergency, responsive to minimum DO'),
('ARM_NIGHT', 'Aeration management: nightime only'),
('ARM_NONE', 'Aeration management: none'),
('ARU_AIRLFT', 'Aeration unit: airlift pump'),
('ARU_FAN', 'Aeration unit: fan, circulator'),
('ARU_NONE', 'Aeration unit: none'),
('ARU_SURF', 'Aeration unit: surface agitator, e.g. paddle-wheel'),
('ARU_VENT', 'Aeration unit: surface venturi'),
('FEED_RES', 'Fish feeding protocol: responsive to fish weight samples'),
('FEED_SCH', 'Fish feeding protocol: pre-defined schedule'),
('FERT_PER', 'Fertilization: culture-period application (after fish stocking)'),
('FERT_PRE', 'Fertilization protocol, pre-specified'),
('FERT_RES', 'Fertilization protocol, responsive (e.g. using Pond)'),
('FERT_SCH', 'Fertilization protocol: pre-specified schedule'),
('FISH_HAR', 'Fish harvest'),
('FISH_OBS', 'Fish observation'),
('FISH_SAM', 'Fish sampling, weight sampling'),
('FISH_STK', 'Fish stocking'),
('WAT_ADD_N', 'Water added, no'),
('WAT_ADD_Y', 'Water added, yes'),
('WAT_FLOW', 'Water management: flowing (exchange rate specified elsewhere)'),
('WAT_OVER_N', 'Water overflow, no'),
('WAT_OVER_Y', 'Water overflow, yes'),
('WAT_STATIC', 'Water management: static with evaporative makeup');
